﻿<?xml version="1.0" encoding="utf-8" ?>
<TestSuite xmlns="http://tempuri.org/SsisUnit.xsd">
  <ConnectionList>
    <Connection name="AdventureWorks" connectionType="ConnectionString" connection="Data Source=localhost;Initial Catalog=AdventureWorks;Provider=SQLNCLI10;Integrated Security=SSPI;"/>
  </ConnectionList>
  <TestSuiteSetup>
    <SqlCommand connectionRef="AdventureWorks" returnsValue="false">
      CREATE TABLE [dbo].[TestTable](
      [ID] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
      [ColName] [varchar](50) NOT NULL)
    </SqlCommand>
  </TestSuiteSetup>
  <Setup>
  </Setup>
  <Tests>
    <Test name="TestRowCount" package="C:\Projects\SSISUnit\SSIS2005\SSIS2005\UT_Simple.dtsx" task="{5661EB8F-527A-460B-B7F5-2C8E066130B7}" >
      <Assert name="RowCount" expectedResult="0" testBefore="false">
        <SqlCommand connectionRef="AdventureWorks" returnsValue="true">
          SELECT COUNT(1) FROM TestTable
        </SqlCommand>
      </Assert>
    </Test>
    <TestRef path="C:\Projects\SSISUnit\UTssisUnit\UTSsisUnitChild.xml"/>
  </Tests>
  <Teardown>
    
  </Teardown>
  <TestSuiteTeardown>
    <SqlCommand connectionRef="AdventureWorks" returnsValue="false">
      DROP TABLE dbo.TestTable
    </SqlCommand>
  </TestSuiteTeardown>
</TestSuite>
